from api_1_0 import db

# 工作经验与薪资的关系模型
class ExperienceSalary(db.Model):
    __tablename__ = 'db_experience_salary'
    id = db.Column(db.Integer,primary_key=True,autoincrement=True)
    exp_date = db.Column(db.String(64),nullable=False)
    salary = db.Column(db.Float,nullable=False)

# 学历与薪资的关系模型
class EducationSalary(db.Model):
    __tablename__ = 'db_education_salary'
    id = db.Column(db.Integer,primary_key=True,autoincrement=True)
    edu_level = db.Column(db.String(64),nullable=False)
    salary = db.Column(db.Float,nullable=False)

# 不同城市与Python求职人数的关系模型
class CityJobs(db.Model):
    __tablename__  = 'db_city_jobs'
    id = db.Column(db.Integer,primary_key=True,autoincrement=True)
    city = db.Column(db.String(64),nullable=False)
    count = db.Column(db.Integer,nullable=False)

# 不同工作经验与求职人数的关系模型
class ExperienceCount(db.Model):
    __tablename__ = 'db_experience_count'
    id = db.Column(db.Integer,primary_key=True,autoincrement=True)
    exp_date = db.Column(db.String(64),nullable=False)
    count = db.Column(db.Integer,nullable=False)

# 不同学历与求职人数的关系模型
class EducationCount(db.Model):
    __tablename__ = 'db_education_count'
    id = db.Column(db.Integer,primary_key=True,autoincrement=True)
    edu_level = db.Column(db.String(64),nullable=False)
    count = db.Column(db.Integer,nullable=False)

# 不同福利类型与求职人数的关系模型
class WelfareCount(db.Model):
    __tablename__ = 'db_welfare_count'
    id = db.Column(db.Integer,primary_key=True,autoincrement=True)
    welfare = db.Column(db.String(64),nullable=True)
    count = db.Column(db.Integer,nullable=False)